package db

import (
	_ "github.com/go-sql-driver/mysql"
	xb "xorm.io/builder"
)

var dbType = "mysql"

func DeviceGroupBuilder(field string) *xb.Builder {
	return xb.Dialect(dbType).Select(field).From("device a").InnerJoin("`group` b", "a.group_id = xb.id").And(xb.Eq{"a.rec_flag": 10})
}
